package dao.v2;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import model.BankVO;
import model.CashRechargeVO;
import model.LogBuyCashVO;
import model.LogCashDrawVO;
import model.LogEarnVO;
import model.OrderPayVO;

public interface MoneyVOMapper {

	String getUnSettledMoney(String member_id);

	void insertDraw(@Param("drawVO")LogCashDrawVO drawVO, @Param("member_id")String member_id, @Param("type")String type, @Param("free_cash")String free_cash);

	List<LogCashDrawVO> selectWithdrawDepositLog(@Param("member_id")String member_id, @Param("logCashDrawVO")LogCashDrawVO logCashDrawVO);

	int selectMemberById(@Param("logcashdraw_id")String logcashdraw_id,@Param("member_id") String member_id);

	LogCashDrawVO selectLogCashDrawOne(@Param("member_id")String member_id, @Param("logcashdraw_id")String logcashdraw_id);

	int getTotal(LogBuyCashVO logBuyCashVO);

	List<LogBuyCashVO> selectLogBuyCashList(LogBuyCashVO logBuyCashVO);

	int getDrawTotal(String member_id);

	int checkLogBuyCashById(String logByCashId);

	LogBuyCashVO selectLogBuyCashOne(@Param("logByCashId")String logByCashId,@Param("member_id")String member_id);

	int getUnSettlementTotal(@Param("member_id")String member_id, @Param("lang")String lang);

	List<LogEarnVO> selectUnSettlementList(@Param("member_id")String member_id, @Param("logEarnVO")LogEarnVO logEarnVO, @Param("lang")String lang);

	int checkUnSettlementOneById(String unSettlement_id);

	LogEarnVO selectUnSettlementOne(@Param("unSettlement_id")String unSettlement_id,@Param("member_id")String member_id);

	int checkIncomeAndExpensesOne(@Param("member_id")String member_id, @Param("incomeAndExpenses_id")String incomeAndExpenses_id);
	LogEarnVO selectIncomeAndExpensesOne(@Param("member_id")String member_id, @Param("incomeAndExpenses_id")String incomeAndExpenses_id);

	int getIncomeAndExpensesTotal(LogEarnVO logEarnVO);

	List<LogEarnVO> selectIncomeAndExpensesList(LogEarnVO logEarnVO);

	void insertLogDraw(LogCashDrawVO drawVO);

	void updateDrawConn(LogCashDrawVO drawVO);

	int subCash(@Param("member_id")String member_id, @Param("free_cash")String free_cash);

	int getWithdrawDepositTotal(@Param("member_id")String member_id, @Param("lang")String lang);

	List<LogEarnVO> selectWithdrawDepositLog(@Param("member_id")String member_id, @Param("logEarnVO")LogEarnVO logEarnVO, @Param("lang")String lang);

	LogEarnVO selectWithdrawDepositLogOne(@Param("member_id")String member_id, @Param("withdrawDeposit_id")String withdrawDeposit_id);

	int insertMoneyRecharge(OrderPayVO payVO);

	String getRechargeNoById(String id);

	CashRechargeVO getRechargeByNo(String out_trade_no);

	void updateRechargeSuccessAndAddCash(CashRechargeVO rechargeVO);

	void deleteRechargeOrderById(String id);

	void insertCashInLog1(OrderPayVO payVO);

	void updateRechargeConnLog(OrderPayVO payVO);

	int addMemberFreeCash(OrderPayVO payVO);

	void updateOrderPayState(OrderPayVO payVO);

	int updateNoReadMessages(List<LogEarnVO> myAssetsList);

	int getMyAssetsTotalById(LogEarnVO logEarnVO);
	
	List<LogEarnVO> selectAllMessageById(LogEarnVO logEarnVO);

	BankVO getDrawBank(String id);

	LogCashDrawVO getLogCashDrawById(String id);

	void updateDrawFee(@Param("id") String id, @Param("fee") String fee);

	String getLogTicketByPayId(String id);

	List<LogEarnVO> IncomeTest(LogEarnVO logEarnVO);

	int getUnSettlementOneByIdCount(@Param("unSettlement_id")String unSettlement_id, @Param("member_id")String member_id);

	LogEarnVO selectUnSettlementOne1(@Param("unSettlement_id")String unSettlement_id,@Param("member_id")String member_id);

	int getIncomeAndExpensesOneCount1(@Param("member_id")String member_id, @Param("incomeAndExpenses_id")String incomeAndExpenses_id);

	int getIncomeAndExpensesOneCount2(@Param("member_id")String member_id, @Param("incomeAndExpenses_id")String incomeAndExpenses_id);

	LogEarnVO selectIncomeAndExpensesOne1(@Param("member_id")String member_id, @Param("incomeAndExpenses_id")String incomeAndExpenses_id);

	LogEarnVO selectIncomeAndExpensesOne2(@Param("member_id")String member_id, @Param("incomeAndExpenses_id")String incomeAndExpenses_id);

	int getLogBuyCashOneCount1(@Param("logByCashId")String logByCashId,@Param("member_id")String member_id);

	int getLogBuyCashOneCount2(@Param("logByCashId")String logByCashId,@Param("member_id")String member_id);

	LogBuyCashVO selectLogBuyCashOne1(@Param("logByCashId")String logByCashId,@Param("member_id")String member_id);

	LogBuyCashVO selectLogBuyCashOne2(@Param("logByCashId")String logByCashId,@Param("member_id")String member_id);

	List<LogEarnVO> selectRechargeTicketAwardList(@Param("member_id")String memberId, @Param("conn_no")String connNo);

	List<LogEarnVO> selectBuyGoodsProfitAwardList(@Param("member_id")String memberId, @Param("order_id")String order_id);

	List<LogEarnVO> selectBuyGoodsPackageProfitAwardList(@Param("member_id")String memberId, @Param("order_id")String order_id);

	String getIncomeSumMoney(String member_id);

	String getUnSettledMoneyEn(String member_id);

	int subCashEn(@Param("member_id") String member_id, @Param("free_cash") String free_cash);

	void insertDrawInter(@Param("drawVO") LogCashDrawVO drawVO, @Param("member_id") String member_id, @Param("type") String type, @Param("free_cash") String free_cash);

	void insertLogDrawInter(LogCashDrawVO draw);

	int addMemberFreeCashEn(OrderPayVO payVO);

	String getRateCash(String id);

}


